Longitude Output Registry entry

Specify the format in which longitude values will display in a client when retrieved from a database.

Usage

This Registry entry can be assigned to users, groups and system-wide:

Key User Group Key System
Key 1 User Group Key 1 System
Key 2 user group Key 2 Setting
Key 3 Setting Key 3 Format
Key 4 Format Key 4 Longitude Output
Key 5 Longitude Output    
Value format Value format

where:

format

is a series of special characters.

The following table illustrates two things:

  1. Available format characters.
  2. The result that will be displayed for each format (demonstrating possible consequences for precision).

Format

If original value is:

The result will be:

Comment

 

d

9 30 45 E

9

The (whole number) degree component.

dd

9 30 45 E

09

The (whole number) degree component. Values less than 10 get a leading zero.

ddd

9 30 45 E

009

The (whole number) degree component. Values less than 100 get two leading zeros.

m

9 6 45 E

6

The (whole number) minute component.

mm

9 6 45 E

06

The (whole number) minute component. Values less than 10 get a leading zero.

s

9 30 5 E

5

The second component rounded to a whole number. This may imply more or less precision than exists in the original value (see examples below).

ss

9 30 5 E

05

The second component rounded to a whole number. This may imply more or less precision than exists in the original value. Values less than 10 get a leading zero.

s

9 30 5.3 E

5

(Less precision implied).

s.s

9 30 5.3 E

5.3

 

s.ss

9 30 5.3 E

5.30

(More precision implied).

s.ss

9 30 5.36666 E

5.37

(Less precision implied).

s.sss

9 30 5.36666 E

5.367

(Less precision implied).

S

9 30 5.3 E

5.3

The second component shown with the level of precision that exists in the original value.

SS

9 30 5.3 E

05.3

The second component shown with the level of precision that exists in the original value. Values less than 10 get a leading zero.

S

9 30 5.36 E

5.36

 

S

9 30 5.36666 E

5.36666

 

M

9 6 30 E

6.5

The minute and second values combined expressed as decimal minutes. The precision of the result is based on the precision of the original value.

M

9 6 30.0 E

6.50

 

M

9 6 30.00 E

6.500

 

MM

9 6 30 E

06.5

The minute and second values combined expressed as decimal minutes. The precision of the result is based on the precision of the original value. Values less than 10 get a leading zero.

g

9 30 E

9.5

The full value (degrees, minutes and seconds) combined and expressed as decimal degrees. The precision of the result is based on the precision of the original value.

g

9 30 0 E

9.500

 

g

9 30 0.0 E

9.5000

 

gg

9 30 E

09.5

 

ggg

9 30 E

009.5

 

G

9 30 E

+9.5

The same as for g but with the value prefixed with a '+' for easterly values or '-' for westerly values.

G

9 30 W

-9.5

 

H

9 30 E

9.5

The same as for G but only westerly values are prefixed. This format is useful for feeding to mapping and other programs which require numeric values.

H

9 30 W

-9.5

 

HHH

9 30 W

-009.5

 

D

 

 

Direction. Will display as E or W.

Some useful longitude formats are:

Format

Result similar to

ddd mm ss D

005 07 15 W

ddd mm SS D

005 07 15.4 W

ddd° M"'" D

005° 7.25' W

Note the use of double quotes around the ': "'"

H

-5.12083

Note: The format characters can be combined to create the desired longitude string, separated by any other character(s).